


USE [abyx_svcm]
GO

--Backup DB with initialize backup media option
DECLARE @bakpath varchar(max)
SET @bakpath=N'D:\Temp\abyx-svcm-20120619-Daily.bak'

BACKUP DATABASE [abyx_svcm] 
TO DISK = @bakpath 
WITH INIT,CHECKSUM,STOP_ON_ERROR;

RESTORE VERIFYONLY
FROM DISK = @bakpath;

USE master;

RESTORE DATABASE [abyx_svcm] 
FROM DISK = @bakpath
WITH RECOVERY, REPLACE;



